from sqlalchemy import Column, DateTime, Float, Integer, String
from database.db_init import Base


class Meteorology(Base):
    __tablename__ = "Meteorology"
    ID = Column(Integer, primary_key=True, index=True)
    RetrievalTime = Column(DateTime, unique=False)
    FarmID = Column(Integer, unique=False)
    MaxTemperature = Column(Float, unique=False)
    MinTemperature = Column(Float, unique=False)
    AvgVaporPressure = Column(Float, unique=False)
    WindSpeed = Column(Float, unique=False)
    Precipitation = Column(Float, unique=False)
    GlobalRadiation = Column(Float, unique=False)
    OtherIndicators = Column(String, unique=False)
